Summary Information

Due to the school closures during COVID-19, over a billion children are at risk of falling behind in school. To keep students safe, countries have implemented virtual learning and we believe that this change has affected countless students. Our group wanted to explore this domain more, as we are all students pursuing higher education. We tried to look at the impacts of COVID-19 on the global education system to see if there were any national trends correlated with Covid-19.

Aggregate Table Script

Total Cases of COVID-19 from Colleges and Universities in Each State（updated on 2021-05-26）

state state_sum
Alabama 15975
Alaska 430
American Samoa 0
Arizona 16419
Arkansas 10675
California 21668
Colorado 14647
Connecticut 8943
Delaware 3264
Florida 35499
Georgia 23235
Guam 12
Hawaii 153
Idaho 7570
Illinois 23642
Indiana 31937
Iowa 11191
Kansas 7030
Kentucky 13956
Louisiana 11460
Maine 1689
Marshall Islands 0
Maryland 7389
Massachusetts 18347
Michigan 26781
Minnesota 14837
Mississippi 6132
Missouri 16290
Montana 3791
Nebraska 8544
Nevada 2905
New Hampshire 4534
New Jersey 9330
New Mexico 1744
New York 38967
North Carolina 26421
North Dakota 5280
Northern Mariana Islands 0
Ohio 31877
Oklahoma 7653
Oregon 4505
Pennsylvania 36732
Puerto Rico 118
Rhode Island 5189
South Carolina 20899
South Dakota 3286
Tennessee 18365
Texas 51632
Utah 17374
Vermont 1405
Virgin Islands 6
Virginia 20423
Washington 7531
Washington, D.C. 2439
West Virginia 4913
Wisconsin 20591
Wyoming 2548
  • The table shows the cases of COVID-19 from each state’s colleges and universities, including every four-year public institution and every private college that competes in N.C.A.A. sports, by May 26, 2021.
  • The variable “state_sum” is the total number of reported Covid-19 cases among university students and employees in all fields in each state since the beginning of the pandemic.
  • Colleges and universities in Texas has the highest number of COVID cases since the beginning of the pandemic by May 26, 2021.

Chart Scripts

Chart 1

The following chart show the top 20 countries with the longest school closure. We can see that the difference between one country and other are very significant. Even though the pandemic was global issue the action each country implemented was different.

Chart 2

This chart is made from “COVID-19 Vaccination and Case Trends by Age Group, United States” dataset collected by CDC (Centers for Disease Control and Prevention). It shows the COVID-19 Vaccination Trends in 2021 in people aged from 12 to 24 in United States. The result chart reveals that there was a great increase of people accepting vaccination from April, but the total percentage till now is still very low and people who accepted one dose is about a time more than those who complete a whole serie. A surprising fact exposed by the chart is that, there are more people get vaccination from 12 to 17 group than those from 18 to 24.

Chart 3

Here we see a scatter plot depicting the countries with the highest level of Covid Testing policies (3), which means that tests are avaliable to everyone, whether they have symptoms or not. Each dot depicts a country and the number of days this policy has been available. Data for this map was gathered from Our World in Data.